package com.tangyh.basic.utils.oldProject;

import javax.imageio.ImageIO;
import java.awt.*;
import java.awt.image.BufferedImage;
import java.io.ByteArrayOutputStream;
import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


public class ExcelTool {

    private static String path = "D:\\a.xls";
    private final static String defaultName = "c.xls";

    public static String getPath() {
        return path;
    }

    public static void setPath(String p) {
        path = p;
    }

    //这个MAIN方法是个DEMO 可以参照这个写法
    public static void main(String[] arg) {
        //       AviatorHealthCheck bean = new AviatorHealthCheck();实体类

//        bean.setId("3FCB19B440E74DF1BD50CD123A3C087C");
//        bean.setHealthCheckFlightNum("NB-38-54321");
//
//        Staff s = new Staff(); //声明一个实体类
//        s.setName("王八");     
//        bean.setFollowDoctor(s);
//
//        bean.setNoddeid("878787");
//        bean.setStartTime("1987-02-25");
//        bean.setEndTime("1987-02-25");
//        bean.setFollowContext("脸可大饿，打瞌睡，而开发，奥东科咳咳咳什么刺激附近的库斯科到看风景的库斯科，道可服务端");

        Map<String, Object> map = new HashMap<String, Object>();   //声明一个map
//        map.put("AviatorHealthCheck", bean);  //将实体放入Map,因为是按Map输出的
/**
 *下面这个是循环用的
 */
        List<Object> list = new ArrayList<Object>();

        for (int i = 0; i < 6; i++) {
//            bean = new AviatorHealthCheck();

//            bean.setId("3FCB19B440E74DF1BD50CD123A3C087C"+"----"+i);
//            bean.setHealthCheckFlightNum("NB-38-54321"+"----"+i);

//            s = new Staff();
//            s.setName("王八"+"----"+i);
//            bean.setFollowDoctor(s);
//
//            bean.setNoddeid("878787"+"----"+i);
//            bean.setStartTime("1987-02-25"+"----"+i);
//            bean.setEndTime("1987-02-25"+"----"+i);
//            bean.setFollowContext("脸可大饿，打瞌睡，而开发，奥东科咳咳咳什么刺激附近的库斯科到看风景的库斯科，道可服务端"+"----"+i);
//            list.add(bean);
        }
        map.put("listname", list);
        map.put("sheets", "肝一");
        List<Map<String, Object>> datas = new ArrayList<>();
        datas.add(map);
        Map<String, Object> map1 = new HashMap<String, Object>();
        map1.put("listname", list);
        map1.put("sheets", "东科咳咳咳什么刺激附近");
        datas.add(map1);
        try {
            BufferedImage bufferImg = null;
            ByteArrayOutputStream byteArrayOut1 = new ByteArrayOutputStream();
            String imgurl = "D:/svn/sc/qj-hqsc/upms/upms-server/src/main/webapp/resources/hqsc/templete/codeImg/20201218/281bf8ed386c4a91b8e6e5e2eedddbfc.jpg";
            Image img = ImageIO.read(new File(imgurl));
            bufferImg = Rotate(img, 270);
            File outputfile = new File("D:/svn/sc/qj-hqsc/upms/upms-server/src/main/webapp/resources/hqsc/templete/codeImg/20201218/image.jpg");
            ImageIO.write(bufferImg, "jpg", outputfile);
        } catch (Exception e) {
            e.printStackTrace();
        }


/**这是循环结束了*/
//        exportExcelCopySheet(path, datas);   //这个最主要，是导出Excel的方法
    }

    /**
     * 对图片进行旋转
     *
     * @param src   被旋转图片
     * @param angel 旋转角度
     * @return 旋转后的图片
     */
    public static BufferedImage Rotate(Image src, int angel) {
        int src_width = src.getWidth(null);
        int src_height = src.getHeight(null);
        // 计算旋转后图片的尺寸
        Rectangle rect_des = CalcRotatedSize(new Rectangle(new Dimension(
                src_width, src_height)), angel);
        BufferedImage res = null;
        res = new BufferedImage(rect_des.width, rect_des.height,
                BufferedImage.TYPE_INT_RGB);
        Graphics2D g2 = res.createGraphics();
        // 进行转换
        g2.translate((rect_des.width - src_width) / 2,
                (rect_des.height - src_height) / 2);
        g2.rotate(Math.toRadians(angel), src_width / 2, src_height / 2);

        g2.drawImage(src, null, null);
        return res;
    }

    /**
     * 计算旋转后的图片
     *
     * @param src   被旋转的图片
     * @param angel 旋转角度
     * @return 旋转后的图片
     */
    public static Rectangle CalcRotatedSize(Rectangle src, int angel) {
        // 如果旋转的角度大于90度做相应的转换
        if (angel >= 90) {
            if (angel / 90 % 2 == 1) {
                int temp = src.height;
                src.height = src.width;
                src.width = temp;
            }
            angel = angel % 90;
        }

        double r = Math.sqrt(src.height * src.height + src.width * src.width) / 2;
        double len = 2 * Math.sin(Math.toRadians(angel) / 2) * r;
        double angel_alpha = (Math.PI - Math.toRadians(angel)) / 2;
        double angel_dalta_width = Math.atan((double) src.height / src.width);
        double angel_dalta_height = Math.atan((double) src.width / src.height);

        int len_dalta_width = (int) (len * Math.cos(Math.PI - angel_alpha
                - angel_dalta_width));
        int len_dalta_height = (int) (len * Math.cos(Math.PI - angel_alpha
                - angel_dalta_height));
        int des_width = src.width + len_dalta_width * 2;
        int des_height = src.height + len_dalta_height * 2;
        return new Rectangle(new Dimension(des_width, des_height));
    }


}